﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="sonicERPDataSet" targetNamespace="http://tempuri.org/sonicERPDataSet.xsd" xmlns:mstns="http://tempuri.org/sonicERPDataSet.xsd" xmlns="http://tempuri.org/sonicERPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="sonicERPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="sonicERPConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.sonicERPConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClienteTableAdapter" GeneratorDataComponentClassName="ClienteTableAdapter" Name="Cliente" UserDataComponentName="ClienteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.Cliente" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cliente] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cliente] ([idusuario], [Nome], [Tipo_Cliente], [E_mail], [Dt_cadastro], [Telefone], [Celular], [Rg], [Cpf], [Inscricao_estadual], [Cnpj], [Cep], [Estado], [Cidade], [Rua], [Numero], [Bairro]) VALUES (@idusuario, @Nome, @Tipo_Cliente, @E_mail, @Dt_cadastro, @Telefone, @Celular, @Rg, @Cpf, @Inscricao_estadual, @Cnpj, @Cep, @Estado, @Cidade, @Rua, @Numero, @Bairro)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idusuario, Nome, Tipo_Cliente, E_mail, Dt_cadastro, Telefone, Celular, Rg, Cpf, Inscricao_estadual, Cnpj, Cep, Estado, Cidade, Rua, Numero, Bairro FROM dbo.Cliente</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cliente] SET [idusuario] = @idusuario, [Nome] = @Nome, [Tipo_Cliente] = @Tipo_Cliente, [E_mail] = @E_mail, [Dt_cadastro] = @Dt_cadastro, [Telefone] = @Telefone, [Celular] = @Celular, [Rg] = @Rg, [Cpf] = @Cpf, [Inscricao_estadual] = @Inscricao_estadual, [Cnpj] = @Cnpj, [Cep] = @Cep, [Estado] = @Estado, [Cidade] = @Cidade, [Rua] = @Rua, [Numero] = @Numero, [Bairro] = @Bairro WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Tipo_Cliente" DataSetColumn="Tipo_Cliente" />
              <Mapping SourceColumn="E_mail" DataSetColumn="E_mail" />
              <Mapping SourceColumn="Dt_cadastro" DataSetColumn="Dt_cadastro" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
              <Mapping SourceColumn="Rg" DataSetColumn="Rg" />
              <Mapping SourceColumn="Cpf" DataSetColumn="Cpf" />
              <Mapping SourceColumn="Inscricao_estadual" DataSetColumn="Inscricao_estadual" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Rua" DataSetColumn="Rua" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Cliente_historicoTableAdapter" GeneratorDataComponentClassName="Cliente_historicoTableAdapter" Name="Cliente_historico" UserDataComponentName="Cliente_historicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.Cliente_historico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Cliente_historico] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cliente_historico] ([idcliente], [idusuario], [Nome], [Tipo_Cliente], [E_mail], [Dt_cadastro], [Telefone], [Celular], [Rg], [Cpf], [Inscricao_estadual], [Cnpj], [Cep], [Estado], [Cidade], [Rua], [Numero], [Bairro], [status]) VALUES (@idcliente, @idusuario, @Nome, @Tipo_Cliente, @E_mail, @Dt_cadastro, @Telefone, @Celular, @Rg, @Cpf, @Inscricao_estadual, @Cnpj, @Cep, @Estado, @Cidade, @Rua, @Numero, @Bairro, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idcliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idcliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idcliente, idusuario, Nome, Tipo_Cliente, E_mail, Dt_cadastro, Telefone, Celular, Rg, Cpf, Inscricao_estadual, Cnpj, Cep, Estado, Cidade, Rua, Numero, Bairro, status FROM dbo.Cliente_historico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cliente_historico] SET [idcliente] = @idcliente, [idusuario] = @idusuario, [Nome] = @Nome, [Tipo_Cliente] = @Tipo_Cliente, [E_mail] = @E_mail, [Dt_cadastro] = @Dt_cadastro, [Telefone] = @Telefone, [Celular] = @Celular, [Rg] = @Rg, [Cpf] = @Cpf, [Inscricao_estadual] = @Inscricao_estadual, [Cnpj] = @Cnpj, [Cep] = @Cep, [Estado] = @Estado, [Cidade] = @Cidade, [Rua] = @Rua, [Numero] = @Numero, [Bairro] = @Bairro, [status] = @status WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idcliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idcliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Cliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idcliente" DataSetColumn="idcliente" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Tipo_Cliente" DataSetColumn="Tipo_Cliente" />
              <Mapping SourceColumn="E_mail" DataSetColumn="E_mail" />
              <Mapping SourceColumn="Dt_cadastro" DataSetColumn="Dt_cadastro" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
              <Mapping SourceColumn="Rg" DataSetColumn="Rg" />
              <Mapping SourceColumn="Cpf" DataSetColumn="Cpf" />
              <Mapping SourceColumn="Inscricao_estadual" DataSetColumn="Inscricao_estadual" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Rua" DataSetColumn="Rua" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fornecedorTableAdapter" GeneratorDataComponentClassName="fornecedorTableAdapter" Name="fornecedor" UserDataComponentName="fornecedorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.fornecedor" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[fornecedor] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[fornecedor] ([idusuario], [Nome], [Tipo_Fornecedor], [E_mail], [Dt_cadastro], [Telefone], [Celular], [Rg], [Cpf], [Inscricao_estadual], [Cnpj], [Cep], [Estado], [Cidade], [Rua], [Numero], [contato], [Bairro]) VALUES (@idusuario, @Nome, @Tipo_Fornecedor, @E_mail, @Dt_cadastro, @Telefone, @Celular, @Rg, @Cpf, @Inscricao_estadual, @Cnpj, @Cep, @Estado, @Cidade, @Rua, @Numero, @contato, @Bairro)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Fornecedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idusuario, Nome, Tipo_Fornecedor, E_mail, Dt_cadastro, Telefone, Celular, Rg, Cpf, Inscricao_estadual, Cnpj, Cep, Estado, Cidade, Rua, Numero, contato, Bairro FROM dbo.fornecedor</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[fornecedor] SET [idusuario] = @idusuario, [Nome] = @Nome, [Tipo_Fornecedor] = @Tipo_Fornecedor, [E_mail] = @E_mail, [Dt_cadastro] = @Dt_cadastro, [Telefone] = @Telefone, [Celular] = @Celular, [Rg] = @Rg, [Cpf] = @Cpf, [Inscricao_estadual] = @Inscricao_estadual, [Cnpj] = @Cnpj, [Cep] = @Cep, [Estado] = @Estado, [Cidade] = @Cidade, [Rua] = @Rua, [Numero] = @Numero, [contato] = @contato, [Bairro] = @Bairro WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Fornecedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Tipo_Fornecedor" DataSetColumn="Tipo_Fornecedor" />
              <Mapping SourceColumn="E_mail" DataSetColumn="E_mail" />
              <Mapping SourceColumn="Dt_cadastro" DataSetColumn="Dt_cadastro" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
              <Mapping SourceColumn="Rg" DataSetColumn="Rg" />
              <Mapping SourceColumn="Cpf" DataSetColumn="Cpf" />
              <Mapping SourceColumn="Inscricao_estadual" DataSetColumn="Inscricao_estadual" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Rua" DataSetColumn="Rua" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
              <Mapping SourceColumn="contato" DataSetColumn="contato" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fornecedor_historicoTableAdapter" GeneratorDataComponentClassName="fornecedor_historicoTableAdapter" Name="fornecedor_historico" UserDataComponentName="fornecedor_historicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.fornecedor_historico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[fornecedor_historico] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[fornecedor_historico] ([idfornecedor], [idusuario], [Nome], [Tipo_Fornecedor], [E_mail], [Dt_cadastro], [Telefone], [Celular], [Rg], [Cpf], [Inscricao_estadual], [Cnpj], [Cep], [Estado], [Cidade], [Rua], [Numero], [contato], [Bairro], [status]) VALUES (@idfornecedor, @idusuario, @Nome, @Tipo_Fornecedor, @E_mail, @Dt_cadastro, @Telefone, @Celular, @Rg, @Cpf, @Inscricao_estadual, @Cnpj, @Cep, @Estado, @Cidade, @Rua, @Numero, @contato, @Bairro, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idfornecedor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfornecedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Fornecedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idfornecedor, idusuario, Nome, Tipo_Fornecedor, E_mail, Dt_cadastro, Telefone, Celular, Rg, Cpf, Inscricao_estadual, Cnpj, Cep, Estado, Cidade, Rua, Numero, contato, Bairro, status FROM dbo.fornecedor_historico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[fornecedor_historico] SET [idfornecedor] = @idfornecedor, [idusuario] = @idusuario, [Nome] = @Nome, [Tipo_Fornecedor] = @Tipo_Fornecedor, [E_mail] = @E_mail, [Dt_cadastro] = @Dt_cadastro, [Telefone] = @Telefone, [Celular] = @Celular, [Rg] = @Rg, [Cpf] = @Cpf, [Inscricao_estadual] = @Inscricao_estadual, [Cnpj] = @Cnpj, [Cep] = @Cep, [Estado] = @Estado, [Cidade] = @Cidade, [Rua] = @Rua, [Numero] = @Numero, [contato] = @contato, [Bairro] = @Bairro, [status] = @status WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idfornecedor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfornecedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo_Fornecedor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="E_mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Telefone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Celular" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Rg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cpf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Inscricao_estadual" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cnpj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Cep" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cidade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Numero" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@contato" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="contato" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bairro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idfornecedor" DataSetColumn="idfornecedor" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Tipo_Fornecedor" DataSetColumn="Tipo_Fornecedor" />
              <Mapping SourceColumn="E_mail" DataSetColumn="E_mail" />
              <Mapping SourceColumn="Dt_cadastro" DataSetColumn="Dt_cadastro" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
              <Mapping SourceColumn="Rg" DataSetColumn="Rg" />
              <Mapping SourceColumn="Cpf" DataSetColumn="Cpf" />
              <Mapping SourceColumn="Inscricao_estadual" DataSetColumn="Inscricao_estadual" />
              <Mapping SourceColumn="Cnpj" DataSetColumn="Cnpj" />
              <Mapping SourceColumn="Cep" DataSetColumn="Cep" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="Cidade" DataSetColumn="Cidade" />
              <Mapping SourceColumn="Rua" DataSetColumn="Rua" />
              <Mapping SourceColumn="Numero" DataSetColumn="Numero" />
              <Mapping SourceColumn="contato" DataSetColumn="contato" />
              <Mapping SourceColumn="Bairro" DataSetColumn="Bairro" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="menuTableAdapter" GeneratorDataComponentClassName="menuTableAdapter" Name="menu" UserDataComponentName="menuTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.menu" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[menu] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[menu] ([menu], [idgrupo]) VALUES (@menu, @idgrupo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@menu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="menu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, menu, idgrupo FROM dbo.menu</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[menu] SET [menu] = @menu, [idgrupo] = @idgrupo WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@menu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="menu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="menu" DataSetColumn="menu" />
              <Mapping SourceColumn="idgrupo" DataSetColumn="idgrupo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="menu1TableAdapter" GeneratorDataComponentClassName="menu1TableAdapter" Name="menu1" UserDataComponentName="menu1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.menu1" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[menu1] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[menu1] ([menu], [idgrupo]) VALUES (@menu, @idgrupo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@menu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="menu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, menu, idgrupo FROM dbo.menu1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[menu1] SET [menu] = @menu, [idgrupo] = @idgrupo WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@menu" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="menu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="menu" DataSetColumn="menu" />
              <Mapping SourceColumn="idgrupo" DataSetColumn="idgrupo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MenuGruposTableAdapter" GeneratorDataComponentClassName="MenuGruposTableAdapter" Name="MenuGrupos" UserDataComponentName="MenuGruposTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.MenuGrupos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[MenuGrupos] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MenuGrupos] ([menugrupo]) VALUES (@menugrupo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@menugrupo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="menugrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, menugrupo FROM dbo.MenuGrupos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[MenuGrupos] SET [menugrupo] = @menugrupo WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@menugrupo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="menugrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="menugrupo" DataSetColumn="menugrupo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="menunivelTableAdapter" GeneratorDataComponentClassName="menunivelTableAdapter" Name="menunivel" UserDataComponentName="menunivelTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.menunivel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[menunivel] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[menunivel] ([idmenu], [idnivel], [visible], [idgrupo]) VALUES (@idmenu, @idnivel, @visible, @idgrupo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idmenu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@visible" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="visible" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idmenu, idnivel, visible, idgrupo FROM dbo.menunivel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[menunivel] SET [idmenu] = @idmenu, [idnivel] = @idnivel, [visible] = @visible, [idgrupo] = @idgrupo WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idmenu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@visible" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="visible" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idmenu" DataSetColumn="idmenu" />
              <Mapping SourceColumn="idnivel" DataSetColumn="idnivel" />
              <Mapping SourceColumn="visible" DataSetColumn="visible" />
              <Mapping SourceColumn="idgrupo" DataSetColumn="idgrupo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="menunivel1TableAdapter" GeneratorDataComponentClassName="menunivel1TableAdapter" Name="menunivel1" UserDataComponentName="menunivel1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.menunivel1" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[menunivel1] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[menunivel1] ([idmenu], [visible], [idgrupo], [idnivel]) VALUES (@idmenu, @visible, @idgrupo, @idnivel)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idmenu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@visible" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="visible" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idmenu, visible, idgrupo, idnivel FROM dbo.menunivel1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[menunivel1] SET [idmenu] = @idmenu, [visible] = @visible, [idgrupo] = @idgrupo, [idnivel] = @idnivel WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idmenu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@visible" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="visible" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idgrupo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idgrupo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idmenu" DataSetColumn="idmenu" />
              <Mapping SourceColumn="visible" DataSetColumn="visible" />
              <Mapping SourceColumn="idgrupo" DataSetColumn="idgrupo" />
              <Mapping SourceColumn="idnivel" DataSetColumn="idnivel" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="nivelUsuarioTableAdapter" GeneratorDataComponentClassName="nivelUsuarioTableAdapter" Name="nivelUsuario" UserDataComponentName="nivelUsuarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.nivelUsuario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[nivelUsuario] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[nivelUsuario] ([idusuario], [nivel], [dt_cadastro]) VALUES (@idusuario, @nivel, @dt_cadastro)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idusuario, nivel, dt_cadastro FROM dbo.nivelUsuario</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[nivelUsuario] SET [idusuario] = @idusuario, [nivel] = @nivel, [dt_cadastro] = @dt_cadastro WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="nivel" DataSetColumn="nivel" />
              <Mapping SourceColumn="dt_cadastro" DataSetColumn="dt_cadastro" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="nivelUsuario_historicoTableAdapter" GeneratorDataComponentClassName="nivelUsuario_historicoTableAdapter" Name="nivelUsuario_historico" UserDataComponentName="nivelUsuario_historicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.nivelUsuario_historico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[nivelUsuario_historico] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[nivelUsuario_historico] ([idnivelusuario], [idusuario], [nivel], [dt_cadastro], [status]) VALUES (@idnivelusuario, @idusuario, @nivel, @dt_cadastro, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivelusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivelusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idnivelusuario, idusuario, nivel, dt_cadastro, status FROM dbo.nivelUsuario_historico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[nivelUsuario_historico] SET [idnivelusuario] = @idnivelusuario, [idusuario] = @idusuario, [nivel] = @nivel, [dt_cadastro] = @dt_cadastro, [status] = @status WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivelusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivelusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idnivelusuario" DataSetColumn="idnivelusuario" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="nivel" DataSetColumn="nivel" />
              <Mapping SourceColumn="dt_cadastro" DataSetColumn="dt_cadastro" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsuarioTableAdapter" GeneratorDataComponentClassName="UsuarioTableAdapter" Name="Usuario" UserDataComponentName="UsuarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.Usuario" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Usuario] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Usuario] ([idnivel], [idusuario], [nome], [email], [apelido], [senha], [dt_cadastro], [dt_ultimo_acesso], [ip]) VALUES (@idnivel, @idusuario, @nome, @email, @apelido, @senha, @dt_cadastro, @dt_ultimo_acesso, @ip)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apelido" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apelido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_ultimo_acesso" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_ultimo_acesso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idnivel, idusuario, nome, email, apelido, senha, dt_cadastro, dt_ultimo_acesso, ip FROM dbo.Usuario</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Usuario] SET [idnivel] = @idnivel, [idusuario] = @idusuario, [nome] = @nome, [email] = @email, [apelido] = @apelido, [senha] = @senha, [dt_cadastro] = @dt_cadastro, [dt_ultimo_acesso] = @dt_ultimo_acesso, [ip] = @ip WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apelido" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apelido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_ultimo_acesso" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_ultimo_acesso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idnivel" DataSetColumn="idnivel" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="nome" DataSetColumn="nome" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="apelido" DataSetColumn="apelido" />
              <Mapping SourceColumn="senha" DataSetColumn="senha" />
              <Mapping SourceColumn="dt_cadastro" DataSetColumn="dt_cadastro" />
              <Mapping SourceColumn="dt_ultimo_acesso" DataSetColumn="dt_ultimo_acesso" />
              <Mapping SourceColumn="ip" DataSetColumn="ip" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Usuario_historicoTableAdapter" GeneratorDataComponentClassName="Usuario_historicoTableAdapter" Name="Usuario_historico" UserDataComponentName="Usuario_historicoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.Usuario_historico" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Usuario_historico] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Usuario_historico] ([idcadastro], [idnivel], [idusuario], [nome], [email], [apelido], [senha], [dt_cadastro], [dt_ultimo_acesso], [ip], [status]) VALUES (@idcadastro, @idnivel, @idusuario, @nome, @email, @apelido, @senha, @dt_cadastro, @dt_ultimo_acesso, @ip, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idcadastro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idcadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apelido" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apelido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_ultimo_acesso" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_ultimo_acesso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, idcadastro, idnivel, idusuario, nome, email, apelido, senha, dt_cadastro, dt_ultimo_acesso, ip, status FROM dbo.Usuario_historico</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Usuario_historico] SET [idcadastro] = @idcadastro, [idnivel] = @idnivel, [idusuario] = @idusuario, [nome] = @nome, [email] = @email, [apelido] = @apelido, [senha] = @senha, [dt_cadastro] = @dt_cadastro, [dt_ultimo_acesso] = @dt_ultimo_acesso, [ip] = @ip, [status] = @status WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idcadastro" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idcadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idnivel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusuario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@apelido" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="apelido" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@senha" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="senha" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_cadastro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dt_ultimo_acesso" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dt_ultimo_acesso" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="idcadastro" DataSetColumn="idcadastro" />
              <Mapping SourceColumn="idnivel" DataSetColumn="idnivel" />
              <Mapping SourceColumn="idusuario" DataSetColumn="idusuario" />
              <Mapping SourceColumn="nome" DataSetColumn="nome" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="apelido" DataSetColumn="apelido" />
              <Mapping SourceColumn="senha" DataSetColumn="senha" />
              <Mapping SourceColumn="dt_cadastro" DataSetColumn="dt_cadastro" />
              <Mapping SourceColumn="dt_ultimo_acesso" DataSetColumn="dt_ultimo_acesso" />
              <Mapping SourceColumn="ip" DataSetColumn="ip" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_ApplicationsTableAdapter" GeneratorDataComponentClassName="vw_aspnet_ApplicationsTableAdapter" Name="vw_aspnet_Applications" UserDataComponentName="vw_aspnet_ApplicationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_Applications" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ApplicationName, LoweredApplicationName, ApplicationId, Description FROM dbo.vw_aspnet_Applications</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_MembershipUsersTableAdapter" GeneratorDataComponentClassName="vw_aspnet_MembershipUsersTableAdapter" Name="vw_aspnet_MembershipUsers" UserDataComponentName="vw_aspnet_MembershipUsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_MembershipUsers" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserId, PasswordFormat, MobilePIN, Email, LoweredEmail, PasswordQuestion, PasswordAnswer, IsApproved, IsLockedOut, CreateDate, LastLoginDate, LastPasswordChangedDate, LastLockoutDate, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, Comment, ApplicationId, UserName, MobileAlias, IsAnonymous, LastActivityDate FROM dbo.vw_aspnet_MembershipUsers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_ProfilesTableAdapter" GeneratorDataComponentClassName="vw_aspnet_ProfilesTableAdapter" Name="vw_aspnet_Profiles" UserDataComponentName="vw_aspnet_ProfilesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_Profiles" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserId, LastUpdatedDate, DataSize FROM dbo.vw_aspnet_Profiles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_RolesTableAdapter" GeneratorDataComponentClassName="vw_aspnet_RolesTableAdapter" Name="vw_aspnet_Roles" UserDataComponentName="vw_aspnet_RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_Roles" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ApplicationId, RoleId, RoleName, LoweredRoleName, Description FROM dbo.vw_aspnet_Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_UsersTableAdapter" GeneratorDataComponentClassName="vw_aspnet_UsersTableAdapter" Name="vw_aspnet_Users" UserDataComponentName="vw_aspnet_UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_Users" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ApplicationId, UserId, UserName, LoweredUserName, MobileAlias, IsAnonymous, LastActivityDate FROM dbo.vw_aspnet_Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_UsersInRolesTableAdapter" GeneratorDataComponentClassName="vw_aspnet_UsersInRolesTableAdapter" Name="vw_aspnet_UsersInRoles" UserDataComponentName="vw_aspnet_UsersInRolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_UsersInRoles" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserId, RoleId FROM dbo.vw_aspnet_UsersInRoles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_WebPartState_PathsTableAdapter" GeneratorDataComponentClassName="vw_aspnet_WebPartState_PathsTableAdapter" Name="vw_aspnet_WebPartState_Paths" UserDataComponentName="vw_aspnet_WebPartState_PathsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_WebPartState_Paths" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ApplicationId, PathId, Path, LoweredPath FROM dbo.vw_aspnet_WebPartState_Paths</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_WebPartState_SharedTableAdapter" GeneratorDataComponentClassName="vw_aspnet_WebPartState_SharedTableAdapter" Name="vw_aspnet_WebPartState_Shared" UserDataComponentName="vw_aspnet_WebPartState_SharedTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_WebPartState_Shared" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PathId, DataSize, LastUpdatedDate FROM dbo.vw_aspnet_WebPartState_Shared</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="vw_aspnet_WebPartState_UserTableAdapter" GeneratorDataComponentClassName="vw_aspnet_WebPartState_UserTableAdapter" Name="vw_aspnet_WebPartState_User" UserDataComponentName="vw_aspnet_WebPartState_UserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.vw_aspnet_WebPartState_User" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PathId, UserId, DataSize, LastUpdatedDate FROM dbo.vw_aspnet_WebPartState_User</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SELECTCLIENTETableAdapter" GeneratorDataComponentClassName="SELECTCLIENTETableAdapter" Name="SELECTCLIENTE" UserDataComponentName="SELECTCLIENTETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.SELECTCLIENTE" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SELECTCLIENTE</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtinicio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtfim" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@tipo_cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nome do Cliente" DataSetColumn="Nome do Cliente" />
              <Mapping SourceColumn="Cliente  do Tipo" DataSetColumn="Cliente  do Tipo" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="Data   do Cadastro" DataSetColumn="Data   do Cadastro" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SELECTFORNECEDORTableAdapter" GeneratorDataComponentClassName="SELECTFORNECEDORTableAdapter" Name="SELECTFORNECEDOR" UserDataComponentName="SELECTFORNECEDORTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.SELECTFORNECEDOR" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SELECTFORNECEDOR</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtinicio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtfim" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nomefornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@tipo_fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nome Fornecedor" DataSetColumn="Nome Fornecedor" />
              <Mapping SourceColumn="Fornecedor      do Tipo" DataSetColumn="Fornecedor      do Tipo" />
              <Mapping SourceColumn="E-mail" DataSetColumn="E-mail" />
              <Mapping SourceColumn="Data   do Cadastro" DataSetColumn="Data   do Cadastro" />
              <Mapping SourceColumn="Contato" DataSetColumn="Contato" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SELECTMENUTableAdapter" GeneratorDataComponentClassName="SELECTMENUTableAdapter" Name="SELECTMENU" UserDataComponentName="SELECTMENUTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.SELECTMENU" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SELECTMENU</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="menu" DataSetColumn="menu" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SELECTNIVELTableAdapter" GeneratorDataComponentClassName="SELECTNIVELTableAdapter" Name="SELECTNIVEL" UserDataComponentName="SELECTNIVELTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.SELECTNIVEL" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SELECTNIVEL</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtinicio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtfinal" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nivel" DataSetColumn="Nivel" />
              <Mapping SourceColumn="Data do Cadastro" DataSetColumn="Data do Cadastro" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SELECTTRUETableAdapter" GeneratorDataComponentClassName="SELECTTRUETableAdapter" Name="SELECTTRUE" UserDataComponentName="SELECTTRUETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.SELECTTRUE" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SELECTTRUE</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="visible" DataSetColumn="visible" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SELECTUSUARIOTableAdapter" GeneratorDataComponentClassName="SELECTUSUARIOTableAdapter" Name="SELECTUSUARIO" UserDataComponentName="SELECTUSUARIOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.SELECTUSUARIO" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SELECTUSUARIO</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtinicio" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtfim" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@usuario" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Usuario" DataSetColumn="Usuario" />
              <Mapping SourceColumn="Nivel" DataSetColumn="Nivel" />
              <Mapping SourceColumn="Data do Cadastro" DataSetColumn="Data do Cadastro" />
              <Mapping SourceColumn="Data do Ultimo Acesso" DataSetColumn="Data do Ultimo Acesso" />
              <Mapping SourceColumn="IP" DataSetColumn="IP" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fnStringToIntTableAdapter" GeneratorDataComponentClassName="fnStringToIntTableAdapter" Name="fnStringToInt" UserDataComponentName="fnStringToIntTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.fnStringToInt" DbObjectType="Function" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDs FROM dbo.fnStringToInt(@String)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="String" ColumnName="" DataSourceName="" DataTypeServer="varchar(1000)" DbType="AnsiString" Direction="Input" ParameterName="@String" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDs" DataSetColumn="IDs" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.DELETECLIENTE" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DELETECLIENTE" MethodsParameterType="CLR" Modifier="Public" Name="DELETECLIENTE" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DELETECLIENTE">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.DELETECLIENTE</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.DELETEFORNECEDOR" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DELETEFORNECEDOR" MethodsParameterType="CLR" Modifier="Public" Name="DELETEFORNECEDOR" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DELETEFORNECEDOR">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.DELETEFORNECEDOR</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.DELETEMENU" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DELETEMENU" MethodsParameterType="CLR" Modifier="Public" Name="DELETEMENU" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="DELETEMENU">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.DELETEMENU</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.DELETENIVELUSUARIO" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="DELETENIVELUSUARIO" MethodsParameterType="CLR" Modifier="Public" Name="DELETENIVELUSUARIO" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="DELETENIVELUSUARIO">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.DELETENIVELUSUARIO</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idnivelusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.INSERT_UPDATE_FORNECEDOR" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="INSERT_UPDATE_FORNECEDOR" MethodsParameterType="CLR" Modifier="Public" Name="INSERT_UPDATE_FORNECEDOR" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="INSERT_UPDATE_FORNECEDOR">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.INSERT_UPDATE_FORNECEDOR</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@tipo_fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@telefone" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@celular" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@rg" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cpf" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cnpj" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cep" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@estado" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@rua" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@numero" Precision="0" ProviderType="Char" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@contato" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.INSERTCLIENTE" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="INSERTCLIENTE" MethodsParameterType="CLR" Modifier="Public" Name="INSERTCLIENTE" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="INSERTCLIENTE">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.INSERTCLIENTE</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.INSERTMENUNIVEL" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="INSERTMENUNIVEL" MethodsParameterType="CLR" Modifier="Public" Name="INSERTMENUNIVEL" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="INSERTMENUNIVEL">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.INSERTMENUNIVEL</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@visible" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.INSERTNIVELUSUARIO" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="INSERTNIVELUSUARIO" MethodsParameterType="CLR" Modifier="Public" Name="INSERTNIVELUSUARIO" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="INSERTNIVELUSUARIO">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.INSERTNIVELUSUARIO</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.INSERTUSUARIO" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="INSERTUSUARIO" MethodsParameterType="CLR" Modifier="Public" Name="INSERTUSUARIO" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="INSERTUSUARIO">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.INSERTUSUARIO</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@apelido" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@senha" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dt_cadastro" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.UPDATECLIENTE" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UPDATECLIENTE" MethodsParameterType="CLR" Modifier="Public" Name="UPDATECLIENTE" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy9" UserSourceName="UPDATECLIENTE">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.UPDATECLIENTE</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Tipo_Cliente" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@E_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Telefone" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Celular" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Rg" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cpf" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cnpj" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cep" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Rua" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Numero" Precision="0" ProviderType="Char" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.UPDATEFONECEDOR" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UPDATEFONECEDOR" MethodsParameterType="CLR" Modifier="Public" Name="UPDATEFONECEDOR" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy10" UserSourceName="UPDATEFONECEDOR">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.UPDATEFONECEDOR</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nome" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@tipo_fornecedor" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@telefone" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@celular" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@rg" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cpf" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@inscricao_estadual" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cnpj" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cep" Precision="0" ProviderType="Char" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@estado" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@cidade" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@rua" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@numero" Precision="0" ProviderType="Char" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@contato" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@bairro" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.UPDATEMENUNIVEL" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UPDATEMENUNIVEL" MethodsParameterType="CLR" Modifier="Public" Name="UPDATEMENUNIVEL" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy11" UserSourceName="UPDATEMENUNIVEL">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.UPDATEMENUNIVEL</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@visible" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idnivel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idmenu" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.UPDATENIVELUSUARIO" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UPDATENIVELUSUARIO" MethodsParameterType="CLR" Modifier="Public" Name="UPDATENIVELUSUARIO" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy12" UserSourceName="UPDATENIVELUSUARIO">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.UPDATENIVELUSUARIO</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idnivelusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusuario" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@nivel" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.UPDATEUSUARIO" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UPDATEUSUARIO" MethodsParameterType="CLR" Modifier="Public" Name="UPDATEUSUARIO" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy13" UserSourceName="UPDATEUSUARIO">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.UPDATEUSUARIO</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="sonicERPConnectionString (Web.config)" DbObjectName="sonicERP.dbo.UPDATEUSUARIOSENHA" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UPDATEUSUARIOSENHA" MethodsParameterType="CLR" Modifier="Public" Name="UPDATEUSUARIOSENHA" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy14" UserSourceName="UPDATEUSUARIOSENHA">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.UPDATEUSUARIOSENHA</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@senha" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ip" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="sonicERPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="sonicERPDataSet" msprop:Generator_UserDSName="sonicERPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cliente" msprop:Generator_TableClassName="ClienteDataTable" msprop:Generator_TableVarName="tableCliente" msprop:Generator_TablePropName="Cliente" msprop:Generator_RowDeletingName="ClienteRowDeleting" msprop:Generator_UserTableName="Cliente" msprop:Generator_RowChangingName="ClienteRowChanging" msprop:Generator_RowEvHandlerName="ClienteRowChangeEventHandler" msprop:Generator_RowDeletedName="ClienteRowDeleted" msprop:Generator_RowEvArgName="ClienteRowChangeEvent" msprop:Generator_RowChangedName="ClienteRowChanged" msprop:Generator_RowClassName="ClienteRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tipo_Cliente" msprop:Generator_ColumnVarNameInTable="columnTipo_Cliente" msprop:Generator_ColumnPropNameInRow="Tipo_Cliente" msprop:Generator_ColumnPropNameInTable="Tipo_ClienteColumn" msprop:Generator_UserColumnName="Tipo_Cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E_mail" msprop:Generator_ColumnVarNameInTable="columnE_mail" msprop:Generator_ColumnPropNameInRow="E_mail" msprop:Generator_ColumnPropNameInTable="E_mailColumn" msprop:Generator_UserColumnName="E_mail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dt_cadastro" msprop:Generator_ColumnVarNameInTable="columnDt_cadastro" msprop:Generator_ColumnPropNameInRow="Dt_cadastro" msprop:Generator_ColumnPropNameInTable="Dt_cadastroColumn" msprop:Generator_UserColumnName="Dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rg" msprop:Generator_ColumnVarNameInTable="columnRg" msprop:Generator_ColumnPropNameInRow="Rg" msprop:Generator_ColumnPropNameInTable="RgColumn" msprop:Generator_UserColumnName="Rg" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cpf" msprop:Generator_ColumnVarNameInTable="columnCpf" msprop:Generator_ColumnPropNameInRow="Cpf" msprop:Generator_ColumnPropNameInTable="CpfColumn" msprop:Generator_UserColumnName="Cpf" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inscricao_estadual" msprop:Generator_ColumnVarNameInTable="columnInscricao_estadual" msprop:Generator_ColumnPropNameInRow="Inscricao_estadual" msprop:Generator_ColumnPropNameInTable="Inscricao_estadualColumn" msprop:Generator_UserColumnName="Inscricao_estadual" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" msprop:Generator_UserColumnName="Cnpj" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnPropNameInTable="CepColumn" msprop:Generator_UserColumnName="Cep" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn" msprop:Generator_UserColumnName="Cidade" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rua" msprop:Generator_ColumnVarNameInTable="columnRua" msprop:Generator_ColumnPropNameInRow="Rua" msprop:Generator_ColumnPropNameInTable="RuaColumn" msprop:Generator_UserColumnName="Rua" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" msprop:Generator_UserColumnName="Numero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnPropNameInTable="BairroColumn" msprop:Generator_UserColumnName="Bairro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Cliente_historico" msprop:Generator_TableClassName="Cliente_historicoDataTable" msprop:Generator_TableVarName="tableCliente_historico" msprop:Generator_TablePropName="Cliente_historico" msprop:Generator_RowDeletingName="Cliente_historicoRowDeleting" msprop:Generator_UserTableName="Cliente_historico" msprop:Generator_RowChangingName="Cliente_historicoRowChanging" msprop:Generator_RowEvHandlerName="Cliente_historicoRowChangeEventHandler" msprop:Generator_RowDeletedName="Cliente_historicoRowDeleted" msprop:Generator_RowEvArgName="Cliente_historicoRowChangeEvent" msprop:Generator_RowChangedName="Cliente_historicoRowChanged" msprop:Generator_RowClassName="Cliente_historicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idcliente" msprop:Generator_ColumnVarNameInTable="columnidcliente" msprop:Generator_ColumnPropNameInRow="idcliente" msprop:Generator_ColumnPropNameInTable="idclienteColumn" msprop:Generator_UserColumnName="idcliente" type="xs:int" minOccurs="0" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tipo_Cliente" msprop:Generator_ColumnVarNameInTable="columnTipo_Cliente" msprop:Generator_ColumnPropNameInRow="Tipo_Cliente" msprop:Generator_ColumnPropNameInTable="Tipo_ClienteColumn" msprop:Generator_UserColumnName="Tipo_Cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E_mail" msprop:Generator_ColumnVarNameInTable="columnE_mail" msprop:Generator_ColumnPropNameInRow="E_mail" msprop:Generator_ColumnPropNameInTable="E_mailColumn" msprop:Generator_UserColumnName="E_mail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dt_cadastro" msprop:Generator_ColumnVarNameInTable="columnDt_cadastro" msprop:Generator_ColumnPropNameInRow="Dt_cadastro" msprop:Generator_ColumnPropNameInTable="Dt_cadastroColumn" msprop:Generator_UserColumnName="Dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rg" msprop:Generator_ColumnVarNameInTable="columnRg" msprop:Generator_ColumnPropNameInRow="Rg" msprop:Generator_ColumnPropNameInTable="RgColumn" msprop:Generator_UserColumnName="Rg" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cpf" msprop:Generator_ColumnVarNameInTable="columnCpf" msprop:Generator_ColumnPropNameInRow="Cpf" msprop:Generator_ColumnPropNameInTable="CpfColumn" msprop:Generator_UserColumnName="Cpf" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inscricao_estadual" msprop:Generator_ColumnVarNameInTable="columnInscricao_estadual" msprop:Generator_ColumnPropNameInRow="Inscricao_estadual" msprop:Generator_ColumnPropNameInTable="Inscricao_estadualColumn" msprop:Generator_UserColumnName="Inscricao_estadual" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" msprop:Generator_UserColumnName="Cnpj" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnPropNameInTable="CepColumn" msprop:Generator_UserColumnName="Cep" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn" msprop:Generator_UserColumnName="Cidade" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rua" msprop:Generator_ColumnVarNameInTable="columnRua" msprop:Generator_ColumnPropNameInRow="Rua" msprop:Generator_ColumnPropNameInTable="RuaColumn" msprop:Generator_UserColumnName="Rua" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" msprop:Generator_UserColumnName="Numero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnPropNameInTable="BairroColumn" msprop:Generator_UserColumnName="Bairro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fornecedor" msprop:Generator_TableClassName="fornecedorDataTable" msprop:Generator_TableVarName="tablefornecedor" msprop:Generator_TablePropName="fornecedor" msprop:Generator_RowDeletingName="fornecedorRowDeleting" msprop:Generator_UserTableName="fornecedor" msprop:Generator_RowChangingName="fornecedorRowChanging" msprop:Generator_RowEvHandlerName="fornecedorRowChangeEventHandler" msprop:Generator_RowDeletedName="fornecedorRowDeleted" msprop:Generator_RowEvArgName="fornecedorRowChangeEvent" msprop:Generator_RowChangedName="fornecedorRowChanged" msprop:Generator_RowClassName="fornecedorRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tipo_Fornecedor" msprop:Generator_ColumnVarNameInTable="columnTipo_Fornecedor" msprop:Generator_ColumnPropNameInRow="Tipo_Fornecedor" msprop:Generator_ColumnPropNameInTable="Tipo_FornecedorColumn" msprop:Generator_UserColumnName="Tipo_Fornecedor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E_mail" msprop:Generator_ColumnVarNameInTable="columnE_mail" msprop:Generator_ColumnPropNameInRow="E_mail" msprop:Generator_ColumnPropNameInTable="E_mailColumn" msprop:Generator_UserColumnName="E_mail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dt_cadastro" msprop:Generator_ColumnVarNameInTable="columnDt_cadastro" msprop:Generator_ColumnPropNameInRow="Dt_cadastro" msprop:Generator_ColumnPropNameInTable="Dt_cadastroColumn" msprop:Generator_UserColumnName="Dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rg" msprop:Generator_ColumnVarNameInTable="columnRg" msprop:Generator_ColumnPropNameInRow="Rg" msprop:Generator_ColumnPropNameInTable="RgColumn" msprop:Generator_UserColumnName="Rg" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cpf" msprop:Generator_ColumnVarNameInTable="columnCpf" msprop:Generator_ColumnPropNameInRow="Cpf" msprop:Generator_ColumnPropNameInTable="CpfColumn" msprop:Generator_UserColumnName="Cpf" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inscricao_estadual" msprop:Generator_ColumnVarNameInTable="columnInscricao_estadual" msprop:Generator_ColumnPropNameInRow="Inscricao_estadual" msprop:Generator_ColumnPropNameInTable="Inscricao_estadualColumn" msprop:Generator_UserColumnName="Inscricao_estadual" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" msprop:Generator_UserColumnName="Cnpj" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnPropNameInTable="CepColumn" msprop:Generator_UserColumnName="Cep" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn" msprop:Generator_UserColumnName="Cidade" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rua" msprop:Generator_ColumnVarNameInTable="columnRua" msprop:Generator_ColumnPropNameInRow="Rua" msprop:Generator_ColumnPropNameInTable="RuaColumn" msprop:Generator_UserColumnName="Rua" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" msprop:Generator_UserColumnName="Numero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contato" msprop:Generator_ColumnVarNameInTable="columncontato" msprop:Generator_ColumnPropNameInRow="contato" msprop:Generator_ColumnPropNameInTable="contatoColumn" msprop:Generator_UserColumnName="contato" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnPropNameInTable="BairroColumn" msprop:Generator_UserColumnName="Bairro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fornecedor_historico" msprop:Generator_TableClassName="fornecedor_historicoDataTable" msprop:Generator_TableVarName="tablefornecedor_historico" msprop:Generator_TablePropName="fornecedor_historico" msprop:Generator_RowDeletingName="fornecedor_historicoRowDeleting" msprop:Generator_UserTableName="fornecedor_historico" msprop:Generator_RowChangingName="fornecedor_historicoRowChanging" msprop:Generator_RowEvHandlerName="fornecedor_historicoRowChangeEventHandler" msprop:Generator_RowDeletedName="fornecedor_historicoRowDeleted" msprop:Generator_RowEvArgName="fornecedor_historicoRowChangeEvent" msprop:Generator_RowChangedName="fornecedor_historicoRowChanged" msprop:Generator_RowClassName="fornecedor_historicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idfornecedor" msprop:Generator_ColumnVarNameInTable="columnidfornecedor" msprop:Generator_ColumnPropNameInRow="idfornecedor" msprop:Generator_ColumnPropNameInTable="idfornecedorColumn" msprop:Generator_UserColumnName="idfornecedor" type="xs:int" minOccurs="0" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tipo_Fornecedor" msprop:Generator_ColumnVarNameInTable="columnTipo_Fornecedor" msprop:Generator_ColumnPropNameInRow="Tipo_Fornecedor" msprop:Generator_ColumnPropNameInTable="Tipo_FornecedorColumn" msprop:Generator_UserColumnName="Tipo_Fornecedor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E_mail" msprop:Generator_ColumnVarNameInTable="columnE_mail" msprop:Generator_ColumnPropNameInRow="E_mail" msprop:Generator_ColumnPropNameInTable="E_mailColumn" msprop:Generator_UserColumnName="E_mail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Dt_cadastro" msprop:Generator_ColumnVarNameInTable="columnDt_cadastro" msprop:Generator_ColumnPropNameInRow="Dt_cadastro" msprop:Generator_ColumnPropNameInTable="Dt_cadastroColumn" msprop:Generator_UserColumnName="Dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rg" msprop:Generator_ColumnVarNameInTable="columnRg" msprop:Generator_ColumnPropNameInRow="Rg" msprop:Generator_ColumnPropNameInTable="RgColumn" msprop:Generator_UserColumnName="Rg" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cpf" msprop:Generator_ColumnVarNameInTable="columnCpf" msprop:Generator_ColumnPropNameInRow="Cpf" msprop:Generator_ColumnPropNameInTable="CpfColumn" msprop:Generator_UserColumnName="Cpf" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inscricao_estadual" msprop:Generator_ColumnVarNameInTable="columnInscricao_estadual" msprop:Generator_ColumnPropNameInRow="Inscricao_estadual" msprop:Generator_ColumnPropNameInTable="Inscricao_estadualColumn" msprop:Generator_UserColumnName="Inscricao_estadual" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnpj" msprop:Generator_ColumnVarNameInTable="columnCnpj" msprop:Generator_ColumnPropNameInRow="Cnpj" msprop:Generator_ColumnPropNameInTable="CnpjColumn" msprop:Generator_UserColumnName="Cnpj" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cep" msprop:Generator_ColumnVarNameInTable="columnCep" msprop:Generator_ColumnPropNameInRow="Cep" msprop:Generator_ColumnPropNameInTable="CepColumn" msprop:Generator_UserColumnName="Cep" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cidade" msprop:Generator_ColumnVarNameInTable="columnCidade" msprop:Generator_ColumnPropNameInRow="Cidade" msprop:Generator_ColumnPropNameInTable="CidadeColumn" msprop:Generator_UserColumnName="Cidade" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rua" msprop:Generator_ColumnVarNameInTable="columnRua" msprop:Generator_ColumnPropNameInRow="Rua" msprop:Generator_ColumnPropNameInTable="RuaColumn" msprop:Generator_UserColumnName="Rua" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numero" msprop:Generator_ColumnVarNameInTable="columnNumero" msprop:Generator_ColumnPropNameInRow="Numero" msprop:Generator_ColumnPropNameInTable="NumeroColumn" msprop:Generator_UserColumnName="Numero" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contato" msprop:Generator_ColumnVarNameInTable="columncontato" msprop:Generator_ColumnPropNameInRow="contato" msprop:Generator_ColumnPropNameInTable="contatoColumn" msprop:Generator_UserColumnName="contato" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bairro" msprop:Generator_ColumnVarNameInTable="columnBairro" msprop:Generator_ColumnPropNameInRow="Bairro" msprop:Generator_ColumnPropNameInTable="BairroColumn" msprop:Generator_UserColumnName="Bairro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="menu" msprop:Generator_TableClassName="menuDataTable" msprop:Generator_TableVarName="tablemenu" msprop:Generator_TablePropName="menu" msprop:Generator_RowDeletingName="menuRowDeleting" msprop:Generator_UserTableName="menu" msprop:Generator_RowChangingName="menuRowChanging" msprop:Generator_RowEvHandlerName="menuRowChangeEventHandler" msprop:Generator_RowDeletedName="menuRowDeleted" msprop:Generator_RowEvArgName="menuRowChangeEvent" msprop:Generator_RowChangedName="menuRowChanged" msprop:Generator_RowClassName="menuRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="menu" msprop:Generator_ColumnVarNameInTable="columnmenu" msprop:Generator_ColumnPropNameInRow="menu" msprop:Generator_ColumnPropNameInTable="menuColumn" msprop:Generator_UserColumnName="menu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idgrupo" msprop:Generator_ColumnVarNameInTable="columnidgrupo" msprop:Generator_ColumnPropNameInRow="idgrupo" msprop:Generator_ColumnPropNameInTable="idgrupoColumn" msprop:Generator_UserColumnName="idgrupo" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="menu1" msprop:Generator_TableClassName="menu1DataTable" msprop:Generator_TableVarName="tablemenu1" msprop:Generator_TablePropName="menu1" msprop:Generator_RowDeletingName="menu1RowDeleting" msprop:Generator_UserTableName="menu1" msprop:Generator_RowChangingName="menu1RowChanging" msprop:Generator_RowEvHandlerName="menu1RowChangeEventHandler" msprop:Generator_RowDeletedName="menu1RowDeleted" msprop:Generator_RowEvArgName="menu1RowChangeEvent" msprop:Generator_RowChangedName="menu1RowChanged" msprop:Generator_RowClassName="menu1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="menu" msprop:Generator_ColumnVarNameInTable="columnmenu" msprop:Generator_ColumnPropNameInRow="menu" msprop:Generator_ColumnPropNameInTable="menuColumn" msprop:Generator_UserColumnName="menu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idgrupo" msprop:Generator_ColumnVarNameInTable="columnidgrupo" msprop:Generator_ColumnPropNameInRow="idgrupo" msprop:Generator_ColumnPropNameInTable="idgrupoColumn" msprop:Generator_UserColumnName="idgrupo" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MenuGrupos" msprop:Generator_TableClassName="MenuGruposDataTable" msprop:Generator_TableVarName="tableMenuGrupos" msprop:Generator_TablePropName="MenuGrupos" msprop:Generator_RowDeletingName="MenuGruposRowDeleting" msprop:Generator_UserTableName="MenuGrupos" msprop:Generator_RowChangingName="MenuGruposRowChanging" msprop:Generator_RowEvHandlerName="MenuGruposRowChangeEventHandler" msprop:Generator_RowDeletedName="MenuGruposRowDeleted" msprop:Generator_RowEvArgName="MenuGruposRowChangeEvent" msprop:Generator_RowChangedName="MenuGruposRowChanged" msprop:Generator_RowClassName="MenuGruposRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="menugrupo" msprop:Generator_ColumnVarNameInTable="columnmenugrupo" msprop:Generator_ColumnPropNameInRow="menugrupo" msprop:Generator_ColumnPropNameInTable="menugrupoColumn" msprop:Generator_UserColumnName="menugrupo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="menunivel" msprop:Generator_TableClassName="menunivelDataTable" msprop:Generator_TableVarName="tablemenunivel" msprop:Generator_TablePropName="menunivel" msprop:Generator_RowDeletingName="menunivelRowDeleting" msprop:Generator_UserTableName="menunivel" msprop:Generator_RowChangingName="menunivelRowChanging" msprop:Generator_RowEvHandlerName="menunivelRowChangeEventHandler" msprop:Generator_RowDeletedName="menunivelRowDeleted" msprop:Generator_RowEvArgName="menunivelRowChangeEvent" msprop:Generator_RowChangedName="menunivelRowChanged" msprop:Generator_RowClassName="menunivelRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idmenu" msprop:Generator_ColumnVarNameInTable="columnidmenu" msprop:Generator_ColumnPropNameInRow="idmenu" msprop:Generator_ColumnPropNameInTable="idmenuColumn" msprop:Generator_UserColumnName="idmenu" type="xs:int" minOccurs="0" />
              <xs:element name="idnivel" msprop:Generator_ColumnVarNameInTable="columnidnivel" msprop:Generator_ColumnPropNameInRow="idnivel" msprop:Generator_ColumnPropNameInTable="idnivelColumn" msprop:Generator_UserColumnName="idnivel" type="xs:int" minOccurs="0" />
              <xs:element name="visible" msprop:Generator_ColumnVarNameInTable="columnvisible" msprop:Generator_ColumnPropNameInRow="visible" msprop:Generator_ColumnPropNameInTable="visibleColumn" msprop:Generator_UserColumnName="visible" type="xs:boolean" minOccurs="0" />
              <xs:element name="idgrupo" msprop:Generator_ColumnVarNameInTable="columnidgrupo" msprop:Generator_ColumnPropNameInRow="idgrupo" msprop:Generator_ColumnPropNameInTable="idgrupoColumn" msprop:Generator_UserColumnName="idgrupo" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="menunivel1" msprop:Generator_TableClassName="menunivel1DataTable" msprop:Generator_TableVarName="tablemenunivel1" msprop:Generator_TablePropName="menunivel1" msprop:Generator_RowDeletingName="menunivel1RowDeleting" msprop:Generator_UserTableName="menunivel1" msprop:Generator_RowChangingName="menunivel1RowChanging" msprop:Generator_RowEvHandlerName="menunivel1RowChangeEventHandler" msprop:Generator_RowDeletedName="menunivel1RowDeleted" msprop:Generator_RowEvArgName="menunivel1RowChangeEvent" msprop:Generator_RowChangedName="menunivel1RowChanged" msprop:Generator_RowClassName="menunivel1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idmenu" msprop:Generator_ColumnVarNameInTable="columnidmenu" msprop:Generator_ColumnPropNameInRow="idmenu" msprop:Generator_ColumnPropNameInTable="idmenuColumn" msprop:Generator_UserColumnName="idmenu" type="xs:int" minOccurs="0" />
              <xs:element name="visible" msprop:Generator_ColumnVarNameInTable="columnvisible" msprop:Generator_ColumnPropNameInRow="visible" msprop:Generator_ColumnPropNameInTable="visibleColumn" msprop:Generator_UserColumnName="visible" type="xs:boolean" minOccurs="0" />
              <xs:element name="idgrupo" msprop:Generator_ColumnVarNameInTable="columnidgrupo" msprop:Generator_ColumnPropNameInRow="idgrupo" msprop:Generator_ColumnPropNameInTable="idgrupoColumn" msprop:Generator_UserColumnName="idgrupo" type="xs:int" minOccurs="0" />
              <xs:element name="idnivel" msprop:Generator_ColumnVarNameInTable="columnidnivel" msprop:Generator_ColumnPropNameInRow="idnivel" msprop:Generator_ColumnPropNameInTable="idnivelColumn" msprop:Generator_UserColumnName="idnivel" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="nivelUsuario" msprop:Generator_TableClassName="nivelUsuarioDataTable" msprop:Generator_TableVarName="tablenivelUsuario" msprop:Generator_TablePropName="nivelUsuario" msprop:Generator_RowDeletingName="nivelUsuarioRowDeleting" msprop:Generator_UserTableName="nivelUsuario" msprop:Generator_RowChangingName="nivelUsuarioRowChanging" msprop:Generator_RowEvHandlerName="nivelUsuarioRowChangeEventHandler" msprop:Generator_RowDeletedName="nivelUsuarioRowDeleted" msprop:Generator_RowEvArgName="nivelUsuarioRowChangeEvent" msprop:Generator_RowChangedName="nivelUsuarioRowChanged" msprop:Generator_RowClassName="nivelUsuarioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="nivel" msprop:Generator_ColumnVarNameInTable="columnnivel" msprop:Generator_ColumnPropNameInRow="nivel" msprop:Generator_ColumnPropNameInTable="nivelColumn" msprop:Generator_UserColumnName="nivel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dt_cadastro" msprop:Generator_ColumnVarNameInTable="columndt_cadastro" msprop:Generator_ColumnPropNameInRow="dt_cadastro" msprop:Generator_ColumnPropNameInTable="dt_cadastroColumn" msprop:Generator_UserColumnName="dt_cadastro" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="nivelUsuario_historico" msprop:Generator_TableClassName="nivelUsuario_historicoDataTable" msprop:Generator_TableVarName="tablenivelUsuario_historico" msprop:Generator_TablePropName="nivelUsuario_historico" msprop:Generator_RowDeletingName="nivelUsuario_historicoRowDeleting" msprop:Generator_UserTableName="nivelUsuario_historico" msprop:Generator_RowChangingName="nivelUsuario_historicoRowChanging" msprop:Generator_RowEvHandlerName="nivelUsuario_historicoRowChangeEventHandler" msprop:Generator_RowDeletedName="nivelUsuario_historicoRowDeleted" msprop:Generator_RowEvArgName="nivelUsuario_historicoRowChangeEvent" msprop:Generator_RowChangedName="nivelUsuario_historicoRowChanged" msprop:Generator_RowClassName="nivelUsuario_historicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idnivelusuario" msprop:Generator_ColumnVarNameInTable="columnidnivelusuario" msprop:Generator_ColumnPropNameInRow="idnivelusuario" msprop:Generator_ColumnPropNameInTable="idnivelusuarioColumn" msprop:Generator_UserColumnName="idnivelusuario" type="xs:int" minOccurs="0" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="nivel" msprop:Generator_ColumnVarNameInTable="columnnivel" msprop:Generator_ColumnPropNameInRow="nivel" msprop:Generator_ColumnPropNameInTable="nivelColumn" msprop:Generator_UserColumnName="nivel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dt_cadastro" msprop:Generator_ColumnVarNameInTable="columndt_cadastro" msprop:Generator_ColumnPropNameInRow="dt_cadastro" msprop:Generator_ColumnPropNameInTable="dt_cadastroColumn" msprop:Generator_UserColumnName="dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Usuario" msprop:Generator_TableClassName="UsuarioDataTable" msprop:Generator_TableVarName="tableUsuario" msprop:Generator_TablePropName="Usuario" msprop:Generator_RowDeletingName="UsuarioRowDeleting" msprop:Generator_UserTableName="Usuario" msprop:Generator_RowChangingName="UsuarioRowChanging" msprop:Generator_RowEvHandlerName="UsuarioRowChangeEventHandler" msprop:Generator_RowDeletedName="UsuarioRowDeleted" msprop:Generator_RowEvArgName="UsuarioRowChangeEvent" msprop:Generator_RowChangedName="UsuarioRowChanged" msprop:Generator_RowClassName="UsuarioRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idnivel" msprop:Generator_ColumnVarNameInTable="columnidnivel" msprop:Generator_ColumnPropNameInRow="idnivel" msprop:Generator_ColumnPropNameInTable="idnivelColumn" msprop:Generator_UserColumnName="idnivel" type="xs:int" minOccurs="0" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="nome" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnPropNameInTable="nomeColumn" msprop:Generator_UserColumnName="nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apelido" msprop:Generator_ColumnVarNameInTable="columnapelido" msprop:Generator_ColumnPropNameInRow="apelido" msprop:Generator_ColumnPropNameInTable="apelidoColumn" msprop:Generator_UserColumnName="apelido" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="senha" msprop:Generator_ColumnVarNameInTable="columnsenha" msprop:Generator_ColumnPropNameInRow="senha" msprop:Generator_ColumnPropNameInTable="senhaColumn" msprop:Generator_UserColumnName="senha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dt_cadastro" msprop:Generator_ColumnVarNameInTable="columndt_cadastro" msprop:Generator_ColumnPropNameInRow="dt_cadastro" msprop:Generator_ColumnPropNameInTable="dt_cadastroColumn" msprop:Generator_UserColumnName="dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dt_ultimo_acesso" msprop:Generator_ColumnVarNameInTable="columndt_ultimo_acesso" msprop:Generator_ColumnPropNameInRow="dt_ultimo_acesso" msprop:Generator_ColumnPropNameInTable="dt_ultimo_acessoColumn" msprop:Generator_UserColumnName="dt_ultimo_acesso" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ip" msprop:Generator_ColumnVarNameInTable="columnip" msprop:Generator_ColumnPropNameInRow="ip" msprop:Generator_ColumnPropNameInTable="ipColumn" msprop:Generator_UserColumnName="ip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Usuario_historico" msprop:Generator_TableClassName="Usuario_historicoDataTable" msprop:Generator_TableVarName="tableUsuario_historico" msprop:Generator_TablePropName="Usuario_historico" msprop:Generator_RowDeletingName="Usuario_historicoRowDeleting" msprop:Generator_UserTableName="Usuario_historico" msprop:Generator_RowChangingName="Usuario_historicoRowChanging" msprop:Generator_RowEvHandlerName="Usuario_historicoRowChangeEventHandler" msprop:Generator_RowDeletedName="Usuario_historicoRowDeleted" msprop:Generator_RowEvArgName="Usuario_historicoRowChangeEvent" msprop:Generator_RowChangedName="Usuario_historicoRowChanged" msprop:Generator_RowClassName="Usuario_historicoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="idcadastro" msprop:Generator_ColumnVarNameInTable="columnidcadastro" msprop:Generator_ColumnPropNameInRow="idcadastro" msprop:Generator_ColumnPropNameInTable="idcadastroColumn" msprop:Generator_UserColumnName="idcadastro" type="xs:int" minOccurs="0" />
              <xs:element name="idnivel" msprop:Generator_ColumnVarNameInTable="columnidnivel" msprop:Generator_ColumnPropNameInRow="idnivel" msprop:Generator_ColumnPropNameInTable="idnivelColumn" msprop:Generator_UserColumnName="idnivel" type="xs:int" minOccurs="0" />
              <xs:element name="idusuario" msprop:Generator_ColumnVarNameInTable="columnidusuario" msprop:Generator_ColumnPropNameInRow="idusuario" msprop:Generator_ColumnPropNameInTable="idusuarioColumn" msprop:Generator_UserColumnName="idusuario" type="xs:int" minOccurs="0" />
              <xs:element name="nome" msprop:Generator_ColumnVarNameInTable="columnnome" msprop:Generator_ColumnPropNameInRow="nome" msprop:Generator_ColumnPropNameInTable="nomeColumn" msprop:Generator_UserColumnName="nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="apelido" msprop:Generator_ColumnVarNameInTable="columnapelido" msprop:Generator_ColumnPropNameInRow="apelido" msprop:Generator_ColumnPropNameInTable="apelidoColumn" msprop:Generator_UserColumnName="apelido" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="senha" msprop:Generator_ColumnVarNameInTable="columnsenha" msprop:Generator_ColumnPropNameInRow="senha" msprop:Generator_ColumnPropNameInTable="senhaColumn" msprop:Generator_UserColumnName="senha" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dt_cadastro" msprop:Generator_ColumnVarNameInTable="columndt_cadastro" msprop:Generator_ColumnPropNameInRow="dt_cadastro" msprop:Generator_ColumnPropNameInTable="dt_cadastroColumn" msprop:Generator_UserColumnName="dt_cadastro" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dt_ultimo_acesso" msprop:Generator_ColumnVarNameInTable="columndt_ultimo_acesso" msprop:Generator_ColumnPropNameInRow="dt_ultimo_acesso" msprop:Generator_ColumnPropNameInTable="dt_ultimo_acessoColumn" msprop:Generator_UserColumnName="dt_ultimo_acesso" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ip" msprop:Generator_ColumnVarNameInTable="columnip" msprop:Generator_ColumnPropNameInRow="ip" msprop:Generator_ColumnPropNameInTable="ipColumn" msprop:Generator_UserColumnName="ip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_Applications" msprop:Generator_TableClassName="vw_aspnet_ApplicationsDataTable" msprop:Generator_TableVarName="tablevw_aspnet_Applications" msprop:Generator_TablePropName="vw_aspnet_Applications" msprop:Generator_RowDeletingName="vw_aspnet_ApplicationsRowDeleting" msprop:Generator_UserTableName="vw_aspnet_Applications" msprop:Generator_RowChangingName="vw_aspnet_ApplicationsRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_ApplicationsRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_ApplicationsRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_ApplicationsRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_ApplicationsRowChanged" msprop:Generator_RowClassName="vw_aspnet_ApplicationsRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_MembershipUsers" msprop:Generator_TableClassName="vw_aspnet_MembershipUsersDataTable" msprop:Generator_TableVarName="tablevw_aspnet_MembershipUsers" msprop:Generator_TablePropName="vw_aspnet_MembershipUsers" msprop:Generator_RowDeletingName="vw_aspnet_MembershipUsersRowDeleting" msprop:Generator_UserTableName="vw_aspnet_MembershipUsers" msprop:Generator_RowChangingName="vw_aspnet_MembershipUsersRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_MembershipUsersRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_MembershipUsersRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_MembershipUsersRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_MembershipUsersRowChanged" msprop:Generator_RowClassName="vw_aspnet_MembershipUsersRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_Profiles" msprop:Generator_TableClassName="vw_aspnet_ProfilesDataTable" msprop:Generator_TableVarName="tablevw_aspnet_Profiles" msprop:Generator_TablePropName="vw_aspnet_Profiles" msprop:Generator_RowDeletingName="vw_aspnet_ProfilesRowDeleting" msprop:Generator_UserTableName="vw_aspnet_Profiles" msprop:Generator_RowChangingName="vw_aspnet_ProfilesRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_ProfilesRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_ProfilesRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_ProfilesRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_ProfilesRowChanged" msprop:Generator_RowClassName="vw_aspnet_ProfilesRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_Roles" msprop:Generator_TableClassName="vw_aspnet_RolesDataTable" msprop:Generator_TableVarName="tablevw_aspnet_Roles" msprop:Generator_TablePropName="vw_aspnet_Roles" msprop:Generator_RowDeletingName="vw_aspnet_RolesRowDeleting" msprop:Generator_UserTableName="vw_aspnet_Roles" msprop:Generator_RowChangingName="vw_aspnet_RolesRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_RolesRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_RolesRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_RolesRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_RolesRowChanged" msprop:Generator_RowClassName="vw_aspnet_RolesRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_Users" msprop:Generator_TableClassName="vw_aspnet_UsersDataTable" msprop:Generator_TableVarName="tablevw_aspnet_Users" msprop:Generator_TablePropName="vw_aspnet_Users" msprop:Generator_RowDeletingName="vw_aspnet_UsersRowDeleting" msprop:Generator_UserTableName="vw_aspnet_Users" msprop:Generator_RowChangingName="vw_aspnet_UsersRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_UsersRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_UsersRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_UsersRowChanged" msprop:Generator_RowClassName="vw_aspnet_UsersRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_UsersInRoles" msprop:Generator_TableClassName="vw_aspnet_UsersInRolesDataTable" msprop:Generator_TableVarName="tablevw_aspnet_UsersInRoles" msprop:Generator_TablePropName="vw_aspnet_UsersInRoles" msprop:Generator_RowDeletingName="vw_aspnet_UsersInRolesRowDeleting" msprop:Generator_UserTableName="vw_aspnet_UsersInRoles" msprop:Generator_RowChangingName="vw_aspnet_UsersInRolesRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_UsersInRolesRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_UsersInRolesRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_UsersInRolesRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_UsersInRolesRowChanged" msprop:Generator_RowClassName="vw_aspnet_UsersInRolesRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_WebPartState_Paths" msprop:Generator_TableClassName="vw_aspnet_WebPartState_PathsDataTable" msprop:Generator_TableVarName="tablevw_aspnet_WebPartState_Paths" msprop:Generator_TablePropName="vw_aspnet_WebPartState_Paths" msprop:Generator_RowDeletingName="vw_aspnet_WebPartState_PathsRowDeleting" msprop:Generator_UserTableName="vw_aspnet_WebPartState_Paths" msprop:Generator_RowChangingName="vw_aspnet_WebPartState_PathsRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_WebPartState_PathsRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_WebPartState_PathsRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_WebPartState_PathsRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_WebPartState_PathsRowChanged" msprop:Generator_RowClassName="vw_aspnet_WebPartState_PathsRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_WebPartState_Shared" msprop:Generator_TableClassName="vw_aspnet_WebPartState_SharedDataTable" msprop:Generator_TableVarName="tablevw_aspnet_WebPartState_Shared" msprop:Generator_TablePropName="vw_aspnet_WebPartState_Shared" msprop:Generator_RowDeletingName="vw_aspnet_WebPartState_SharedRowDeleting" msprop:Generator_UserTableName="vw_aspnet_WebPartState_Shared" msprop:Generator_RowChangingName="vw_aspnet_WebPartState_SharedRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_WebPartState_SharedRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_WebPartState_SharedRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_WebPartState_SharedRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_WebPartState_SharedRowChanged" msprop:Generator_RowClassName="vw_aspnet_WebPartState_SharedRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="vw_aspnet_WebPartState_User" msprop:Generator_TableClassName="vw_aspnet_WebPartState_UserDataTable" msprop:Generator_TableVarName="tablevw_aspnet_WebPartState_User" msprop:Generator_TablePropName="vw_aspnet_WebPartState_User" msprop:Generator_RowDeletingName="vw_aspnet_WebPartState_UserRowDeleting" msprop:Generator_UserTableName="vw_aspnet_WebPartState_User" msprop:Generator_RowChangingName="vw_aspnet_WebPartState_UserRowChanging" msprop:Generator_RowEvHandlerName="vw_aspnet_WebPartState_UserRowChangeEventHandler" msprop:Generator_RowDeletedName="vw_aspnet_WebPartState_UserRowDeleted" msprop:Generator_RowEvArgName="vw_aspnet_WebPartState_UserRowChangeEvent" msprop:Generator_RowChangedName="vw_aspnet_WebPartState_UserRowChanged" msprop:Generator_RowClassName="vw_aspnet_WebPartState_UserRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="SELECTCLIENTE" msprop:Generator_TableClassName="SELECTCLIENTEDataTable" msprop:Generator_TableVarName="tableSELECTCLIENTE" msprop:Generator_TablePropName="SELECTCLIENTE" msprop:Generator_RowDeletingName="SELECTCLIENTERowDeleting" msprop:Generator_UserTableName="SELECTCLIENTE" msprop:Generator_RowChangingName="SELECTCLIENTERowChanging" msprop:Generator_RowEvHandlerName="SELECTCLIENTERowChangeEventHandler" msprop:Generator_RowDeletedName="SELECTCLIENTERowDeleted" msprop:Generator_RowEvArgName="SELECTCLIENTERowChangeEvent" msprop:Generator_RowChangedName="SELECTCLIENTERowChanged" msprop:Generator_RowClassName="SELECTCLIENTERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo" type="xs:int" />
              <xs:element name="Nome_x0020_do_x0020_Cliente" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNome_do_Cliente" msprop:Generator_ColumnPropNameInRow="Nome_do_Cliente" msprop:Generator_ColumnPropNameInTable="Nome_do_ClienteColumn" msprop:Generator_UserColumnName="Nome do Cliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cliente_x0020__x0020_do_x0020_Tipo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnCliente__do_Tipo" msprop:Generator_ColumnPropNameInRow="Cliente__do_Tipo" msprop:Generator_ColumnPropNameInTable="Cliente__do_TipoColumn" msprop:Generator_UserColumnName="Cliente  do Tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" msprop:Generator_UserColumnName="E-mail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_x0020__x0020__x0020_do_x0020_Cadastro" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnData___do_Cadastro" msprop:Generator_ColumnPropNameInRow="Data___do_Cadastro" msprop:Generator_ColumnPropNameInTable="Data___do_CadastroColumn" msprop:Generator_UserColumnName="Data   do Cadastro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SELECTFORNECEDOR" msprop:Generator_TableClassName="SELECTFORNECEDORDataTable" msprop:Generator_TableVarName="tableSELECTFORNECEDOR" msprop:Generator_TablePropName="SELECTFORNECEDOR" msprop:Generator_RowDeletingName="SELECTFORNECEDORRowDeleting" msprop:Generator_UserTableName="SELECTFORNECEDOR" msprop:Generator_RowChangingName="SELECTFORNECEDORRowChanging" msprop:Generator_RowEvHandlerName="SELECTFORNECEDORRowChangeEventHandler" msprop:Generator_RowDeletedName="SELECTFORNECEDORRowDeleted" msprop:Generator_RowEvArgName="SELECTFORNECEDORRowChangeEvent" msprop:Generator_RowChangedName="SELECTFORNECEDORRowChanged" msprop:Generator_RowClassName="SELECTFORNECEDORRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo" type="xs:int" />
              <xs:element name="Nome_x0020_Fornecedor" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNome_Fornecedor" msprop:Generator_ColumnPropNameInRow="Nome_Fornecedor" msprop:Generator_ColumnPropNameInTable="Nome_FornecedorColumn" msprop:Generator_UserColumnName="Nome Fornecedor" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fornecedor_x0020__x0020__x0020__x0020__x0020__x0020_do_x0020_Tipo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFornecedor______do_Tipo" msprop:Generator_ColumnPropNameInRow="Fornecedor______do_Tipo" msprop:Generator_ColumnPropNameInTable="Fornecedor______do_TipoColumn" msprop:Generator_UserColumnName="Fornecedor      do Tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="E-mail" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnE_mail" msprop:Generator_ColumnPropNameInRow="_E_mail" msprop:Generator_ColumnPropNameInTable="_E_mailColumn" msprop:Generator_UserColumnName="E-mail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_x0020__x0020__x0020_do_x0020_Cadastro" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnData___do_Cadastro" msprop:Generator_ColumnPropNameInRow="Data___do_Cadastro" msprop:Generator_ColumnPropNameInTable="Data___do_CadastroColumn" msprop:Generator_UserColumnName="Data   do Cadastro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Contato" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnContato" msprop:Generator_ColumnPropNameInRow="Contato" msprop:Generator_ColumnPropNameInTable="ContatoColumn" msprop:Generator_UserColumnName="Contato" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SELECTMENU" msprop:Generator_TableClassName="SELECTMENUDataTable" msprop:Generator_TableVarName="tableSELECTMENU" msprop:Generator_TablePropName="SELECTMENU" msprop:Generator_RowDeletingName="SELECTMENURowDeleting" msprop:Generator_UserTableName="SELECTMENU" msprop:Generator_RowChangingName="SELECTMENURowChanging" msprop:Generator_RowEvHandlerName="SELECTMENURowChangeEventHandler" msprop:Generator_RowDeletedName="SELECTMENURowDeleted" msprop:Generator_RowEvArgName="SELECTMENURowChangeEvent" msprop:Generator_RowChangedName="SELECTMENURowChanged" msprop:Generator_RowClassName="SELECTMENURow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="menu" msprop:Generator_ColumnVarNameInTable="columnmenu" msprop:Generator_ColumnPropNameInRow="menu" msprop:Generator_ColumnPropNameInTable="menuColumn" msprop:Generator_UserColumnName="menu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SELECTNIVEL" msprop:Generator_TableClassName="SELECTNIVELDataTable" msprop:Generator_TableVarName="tableSELECTNIVEL" msprop:Generator_TablePropName="SELECTNIVEL" msprop:Generator_RowDeletingName="SELECTNIVELRowDeleting" msprop:Generator_UserTableName="SELECTNIVEL" msprop:Generator_RowChangingName="SELECTNIVELRowChanging" msprop:Generator_RowEvHandlerName="SELECTNIVELRowChangeEventHandler" msprop:Generator_RowDeletedName="SELECTNIVELRowDeleted" msprop:Generator_RowEvArgName="SELECTNIVELRowChangeEvent" msprop:Generator_RowChangedName="SELECTNIVELRowChanged" msprop:Generator_RowClassName="SELECTNIVELRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo" type="xs:int" />
              <xs:element name="Nivel" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNivel" msprop:Generator_ColumnPropNameInRow="Nivel" msprop:Generator_ColumnPropNameInTable="NivelColumn" msprop:Generator_UserColumnName="Nivel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_x0020_do_x0020_Cadastro" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnData_do_Cadastro" msprop:Generator_ColumnPropNameInRow="Data_do_Cadastro" msprop:Generator_ColumnPropNameInTable="Data_do_CadastroColumn" msprop:Generator_UserColumnName="Data do Cadastro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SELECTTRUE" msprop:Generator_TableClassName="SELECTTRUEDataTable" msprop:Generator_TableVarName="tableSELECTTRUE" msprop:Generator_TablePropName="SELECTTRUE" msprop:Generator_RowDeletingName="SELECTTRUERowDeleting" msprop:Generator_UserTableName="SELECTTRUE" msprop:Generator_RowChangingName="SELECTTRUERowChanging" msprop:Generator_RowEvHandlerName="SELECTTRUERowChangeEventHandler" msprop:Generator_RowDeletedName="SELECTTRUERowDeleted" msprop:Generator_RowEvArgName="SELECTTRUERowChangeEvent" msprop:Generator_RowChangedName="SELECTTRUERowChanged" msprop:Generator_RowClassName="SELECTTRUERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="visible" msprop:Generator_ColumnVarNameInTable="columnvisible" msprop:Generator_ColumnPropNameInRow="visible" msprop:Generator_ColumnPropNameInTable="visibleColumn" msprop:Generator_UserColumnName="visible" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SELECTUSUARIO" msprop:Generator_TableClassName="SELECTUSUARIODataTable" msprop:Generator_TableVarName="tableSELECTUSUARIO" msprop:Generator_TablePropName="SELECTUSUARIO" msprop:Generator_RowDeletingName="SELECTUSUARIORowDeleting" msprop:Generator_UserTableName="SELECTUSUARIO" msprop:Generator_RowChangingName="SELECTUSUARIORowChanging" msprop:Generator_RowEvHandlerName="SELECTUSUARIORowChangeEventHandler" msprop:Generator_RowDeletedName="SELECTUSUARIORowDeleted" msprop:Generator_RowEvArgName="SELECTUSUARIORowChangeEvent" msprop:Generator_RowChangedName="SELECTUSUARIORowChanged" msprop:Generator_RowClassName="SELECTUSUARIORow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Nome" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Usuario" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUsuario" msprop:Generator_ColumnPropNameInRow="Usuario" msprop:Generator_ColumnPropNameInTable="UsuarioColumn" msprop:Generator_UserColumnName="Usuario" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nivel" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNivel" msprop:Generator_ColumnPropNameInRow="Nivel" msprop:Generator_ColumnPropNameInTable="NivelColumn" msprop:Generator_UserColumnName="Nivel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_x0020_do_x0020_Cadastro" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnData_do_Cadastro" msprop:Generator_ColumnPropNameInRow="Data_do_Cadastro" msprop:Generator_ColumnPropNameInTable="Data_do_CadastroColumn" msprop:Generator_UserColumnName="Data do Cadastro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_x0020_do_x0020_Ultimo_x0020_Acesso" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnData_do_Ultimo_Acesso" msprop:Generator_ColumnPropNameInRow="Data_do_Ultimo_Acesso" msprop:Generator_ColumnPropNameInTable="Data_do_Ultimo_AcessoColumn" msprop:Generator_UserColumnName="Data do Ultimo Acesso" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="21" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IP" msprop:Generator_ColumnVarNameInTable="columnIP" msprop:Generator_ColumnPropNameInRow="IP" msprop:Generator_ColumnPropNameInTable="IPColumn" msprop:Generator_UserColumnName="IP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fnStringToInt" msprop:Generator_TableClassName="fnStringToIntDataTable" msprop:Generator_TableVarName="tablefnStringToInt" msprop:Generator_TablePropName="fnStringToInt" msprop:Generator_RowDeletingName="fnStringToIntRowDeleting" msprop:Generator_UserTableName="fnStringToInt" msprop:Generator_RowChangingName="fnStringToIntRowChanging" msprop:Generator_RowEvHandlerName="fnStringToIntRowChangeEventHandler" msprop:Generator_RowDeletedName="fnStringToIntRowDeleted" msprop:Generator_RowEvArgName="fnStringToIntRowChangeEvent" msprop:Generator_RowChangedName="fnStringToIntRowChanged" msprop:Generator_RowClassName="fnStringToIntRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDs" msprop:Generator_ColumnVarNameInTable="columnIDs" msprop:Generator_ColumnPropNameInRow="IDs" msprop:Generator_ColumnPropNameInTable="IDsColumn" msprop:Generator_UserColumnName="IDs" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cliente" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Cliente_historico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cliente_historico" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="fornecedor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:fornecedor" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="fornecedor_historico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:fornecedor_historico" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="menu_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:menu" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="menu1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:menu1" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="MenuGrupos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MenuGrupos" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="menunivel_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:menunivel" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="menunivel1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:menunivel1" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="nivelUsuario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:nivelUsuario" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="nivelUsuario_historico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:nivelUsuario_historico" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Usuario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Usuario" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Usuario_historico_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Usuario_historico" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="SELECTCLIENTE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SELECTCLIENTE" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="SELECTFORNECEDOR_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SELECTFORNECEDOR" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="SELECTMENU_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SELECTMENU" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="SELECTNIVEL_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SELECTNIVEL" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="fk_usuario" msdata:parent="Usuario" msdata:child="Cliente" msdata:parentkey="id" msdata:childkey="idusuario" msprop:Generator_UserChildTable="Cliente" msprop:Generator_ChildPropName="GetClienteRows" msprop:Generator_ParentPropName="UsuarioRow" msprop:Generator_UserRelationName="fk_usuario" msprop:Generator_RelationVarName="relationfk_usuario" msprop:Generator_UserParentTable="Usuario" />
      <msdata:Relationship name="pk_usuario" msdata:parent="Usuario" msdata:child="fornecedor" msdata:parentkey="id" msdata:childkey="idusuario" msprop:Generator_UserChildTable="fornecedor" msprop:Generator_ChildPropName="GetfornecedorRows" msprop:Generator_ParentPropName="UsuarioRow" msprop:Generator_UserRelationName="pk_usuario" msprop:Generator_RelationVarName="relationpk_usuario" msprop:Generator_UserParentTable="Usuario" />
      <msdata:Relationship name="FK_MENUGRUPO" msdata:parent="MenuGrupos" msdata:child="menu1" msdata:parentkey="id" msdata:childkey="idgrupo" msprop:Generator_UserChildTable="menu1" msprop:Generator_ChildPropName="Getmenu1Rows" msprop:Generator_ParentPropName="MenuGruposRow" msprop:Generator_UserRelationName="FK_MENUGRUPO" msprop:Generator_RelationVarName="relationFK_MENUGRUPO" msprop:Generator_UserParentTable="MenuGrupos" />
      <msdata:Relationship name="pk_nivel" msdata:parent="nivelUsuario" msdata:child="Usuario" msdata:parentkey="id" msdata:childkey="idnivel" msprop:Generator_UserChildTable="Usuario" msprop:Generator_ChildPropName="GetUsuarioRows" msprop:Generator_ParentPropName="nivelUsuarioRow" msprop:Generator_UserRelationName="pk_nivel" msprop:Generator_RelationVarName="relationpk_nivel" msprop:Generator_UserParentTable="nivelUsuario" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>